{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/willsec/Desktop/ReplicationFile.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}21 Jul 2021, 17:09:17

{com}. do "/var/folders/6y/zcqr8vt564j_7_nr4xt3jmlw0000gq/T//SD82902.000000"
{txt}
{com}. cd "/Users/willsec/Documents/Centralization and Subnational Capacity/ReplicationFile"
{res}/Users/willsec/Documents/Centralization and Subnational Capacity/ReplicationFile
{txt}
{com}. use "NCES Gov Capacity and NCCS Orgs By Year.dta", clear
{txt}( )

{com}. 
. *****NATIONAL ANALYSIS*****
. 
. //Table 4: Administrative and Technical Capacity ITSA, 1997-2015
. 
. use  "NCES Gov Capacity and NCCS Orgs By Year.dta", replace
{txt}( )

{com}. tsset year
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa admin_weighted, single trperiod(2003 2010) lag(1) fig posttrend //Figure 1


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}     65.83
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}admin_weig~d{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0472356{col 26}{space 2}  .005137{col 37}{space 1}    9.20{col 46}{space 3}0.000{col 54}{space 4} .0361379{col 67}{space 3} .0583334
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.0612521{col 26}{space 2} .0301062{col 37}{space 1}   -2.03{col 46}{space 3}0.063{col 54}{space 4}-.1262925{col 67}{space 3} .0037883
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2} -.044361{col 26}{space 2} .0067512{col 37}{space 1}   -6.57{col 46}{space 3}0.000{col 54}{space 4}-.0589462{col 67}{space 3}-.0297758
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2} .0467197{col 26}{space 2}  .027583{col 37}{space 1}    1.69{col 46}{space 3}0.114{col 54}{space 4}-.0128697{col 67}{space 3} .1063091
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0166576{col 26}{space 2} .0062222{col 37}{space 1}   -2.68{col 46}{space 3}0.019{col 54}{space 4}   -.0301{col 67}{space 3}-.0032153
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 1.030577{col 26}{space 2} .0159923{col 37}{space 1}   64.44{col 46}{space 3}0.000{col 54}{space 4} .9960277{col 67}{space 3} 1.065126
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0029{col 27}   0.0056{col 38}  0.5105{col 48}  0.6183{col 58}  -0.0093{col 68}   0.0150
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0138{col 27}   0.0015{col 38} -8.9594{col 48}  0.0000{col 58}  -0.0171{col 68}  -0.0105
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. 
. eststo national_admin
{txt}
{com}. 
. use  "NCES Gov Capacity and NCCS Orgs By Year.dta", replace
{txt}( )

{com}. tsset year
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa instruction_weighted, single trperiod(2003 2010) lag(1) fig posttrend //Figure 2


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}    683.89
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}instructio~d{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0060986{col 26}{space 2} .0004845{col 37}{space 1}   12.59{col 46}{space 3}0.000{col 54}{space 4} .0050519{col 67}{space 3} .0071453
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2} -.016493{col 26}{space 2} .0073872{col 37}{space 1}   -2.23{col 46}{space 3}0.044{col 54}{space 4}-.0324521{col 67}{space 3}-.0005338
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2} .0052342{col 26}{space 2} .0030437{col 37}{space 1}    1.72{col 46}{space 3}0.109{col 54}{space 4}-.0013412{col 67}{space 3} .0118097
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2}-.0304373{col 26}{space 2}  .016675{col 37}{space 1}   -1.83{col 46}{space 3}0.091{col 54}{space 4}-.0664615{col 67}{space 3}  .005587
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0093164{col 26}{space 2} .0029642{col 37}{space 1}   -3.14{col 46}{space 3}0.008{col 54}{space 4}-.0157201{col 67}{space 3}-.0029127
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0649809{col 26}{space 2} .0013125{col 37}{space 1}   49.51{col 46}{space 3}0.000{col 54}{space 4} .0621454{col 67}{space 3} .0678164
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0113{col 27}   0.0030{col 38}  3.7753{col 48}  0.0023{col 58}   0.0048{col 68}   0.0178
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0020{col 27}   0.0002{col 38} 12.1486{col 48}  0.0000{col 58}   0.0017{col 68}   0.0024
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. 
. eststo national_instruction
{txt}
{com}. 
. estout national_admin national_instruction, cells(b(star fmt(%9.3f)) se(par))                ///
>         stats(r2_a N, fmt(%9.3f %9.0g) labels(R-squared))      ///
>         legend label collabels(none) varlabels(_cons Constant)  
{res}
{txt}{hline 52}
{txt}                     national_a~n    national_i~n   
{txt}{hline 52}
{txt}_t                  {res}        0.047***        0.006***{txt}
                    {res}      (0.005)         (0.000)   {txt}
{txt}_x2003              {res}       -0.061          -0.016*  {txt}
                    {res}      (0.030)         (0.007)   {txt}
{txt}_x_t2003            {res}       -0.044***        0.005   {txt}
                    {res}      (0.007)         (0.003)   {txt}
{txt}_x2010              {res}        0.047          -0.030   {txt}
                    {res}      (0.028)         (0.017)   {txt}
{txt}_x_t2010            {res}       -0.017*         -0.009** {txt}
                    {res}      (0.006)         (0.003)   {txt}
{txt}Constant            {res}        1.031***        0.065***{txt}
                    {res}      (0.016)         (0.001)   {txt}
{txt}{hline 52}
{txt}R-squared           {res}                                {txt}
{txt}N                   {res}           19              19   {txt}
{txt}{hline 52}
{txt}* p<0.05, ** p<0.01, *** p<0.001

{com}. 
. 
. 
. 
. *****SUBGROUP ANALYSIS*****
. 
. use "NCES Capacity and SAIPE County 9715", clear
{txt}
{com}. 
. // divide counties into income quintiles by childhood poverty levels (percent of the population aged 5-17 living in poverty). 
. xtile pov=Pov_517Pct, n(5)
{txt}
{com}. drop if missing(pov)
{txt}(1 observation deleted)

{com}. //(1 observation deleted)
. 
. sum Pov_517Pct if pov==1 //  9.3

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}Pov_517Pct {c |}{res}     12,020    9.275491    2.178428        1.8       12.2
{txt}
{com}. sum Pov_517Pct if pov==5 // 32.8

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 2}Pov_517Pct {c |}{res}     11,688    32.83688    5.589521       26.7       64.6
{txt}
{com}. 
. //collapse for subgroup poverty quintile category
. collapse (sum) teacher libsup libspe leaadm schadm leasup schsup corsup member, by(year pov)
{txt}
{com}. 
. gen admin_county =  leaadm + schadm + leasup + schsup 
{txt}
{com}. gen admin_weighted_county = (admin_county/member)*100
{txt}
{com}. gen instruction_county = (corsup/member)*100
{txt}
{com}. 
. save "NCES Capacity Data and Saipe County Subgroup 9715.dta", replace
{txt}file NCES Capacity Data and Saipe County Subgroup 9715.dta saved

{com}. 
. 
. //Table 5: Administrative Capacity in Low Poverty and High Poverty Counties ITSA, 1997-2015
. 
. //Low Poverty
. use "NCES Capacity Data and Saipe County Subgroup 9715.dta", clear
{txt}
{com}. keep if pov==1 
{txt}(76 observations deleted)

{com}. tsset year 
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa admin_weighted_county, single trperiod(2003 2010) lag(1) fig posttrend //Figure 3


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}     33.02
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}admin_weig~y{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0534106{col 26}{space 2} .0050896{col 37}{space 1}   10.49{col 46}{space 3}0.000{col 54}{space 4} .0424152{col 67}{space 3} .0644061
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.1116294{col 26}{space 2} .0310196{col 37}{space 1}   -3.60{col 46}{space 3}0.003{col 54}{space 4}-.1786431{col 67}{space 3}-.0446157
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2}-.0468014{col 26}{space 2} .0084834{col 37}{space 1}   -5.52{col 46}{space 3}0.000{col 54}{space 4}-.0651286{col 67}{space 3}-.0284742
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2} .1023197{col 26}{space 2} .0498798{col 37}{space 1}    2.05{col 46}{space 3}0.061{col 54}{space 4}-.0054391{col 67}{space 3} .2100786
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0210364{col 26}{space 2} .0088526{col 37}{space 1}   -2.38{col 46}{space 3}0.034{col 54}{space 4}-.0401614{col 67}{space 3}-.0019115
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 1.015976{col 26}{space 2} .0214618{col 37}{space 1}   47.34{col 46}{space 3}0.000{col 54}{space 4} .9696101{col 67}{space 3} 1.062341
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0066{col 27}   0.0074{col 38}  0.8919{col 48}  0.3887{col 58}  -0.0094{col 68}   0.0226
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0144{col 27}   0.0068{col 38} -2.1153{col 48}  0.0543{col 58}  -0.0292{col 68}   0.0003
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. eststo lowpov_admin
{txt}
{com}. 
. //High Poverty
. use "NCES Capacity Data and Saipe County Subgroup 9715.dta", clear
{txt}
{com}. keep if pov==5 
{txt}(76 observations deleted)

{com}. tsset year 
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa admin_weighted_county, single trperiod(2003 2010) lag(1) fig posttrend //Figure 4


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}     19.22
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}admin_weig~y{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0535511{col 26}{space 2} .0108469{col 37}{space 1}    4.94{col 46}{space 3}0.000{col 54}{space 4} .0301179{col 67}{space 3} .0769844
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.1623471{col 26}{space 2} .0981591{col 37}{space 1}   -1.65{col 46}{space 3}0.122{col 54}{space 4} -.374407{col 67}{space 3} .0497129
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2}-.0173095{col 26}{space 2} .0228111{col 37}{space 1}   -0.76{col 46}{space 3}0.461{col 54}{space 4}-.0665898{col 67}{space 3} .0319709
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2}-.0300209{col 26}{space 2} .0549727{col 37}{space 1}   -0.55{col 46}{space 3}0.594{col 54}{space 4}-.1487822{col 67}{space 3} .0887405
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0582052{col 26}{space 2}  .020677{col 37}{space 1}   -2.81{col 46}{space 3}0.015{col 54}{space 4}-.1028752{col 67}{space 3}-.0135352
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 1.004732{col 26}{space 2} .0342937{col 37}{space 1}   29.30{col 46}{space 3}0.000{col 54}{space 4}  .930645{col 67}{space 3} 1.078819
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0362{col 27}   0.0191{col 38}  1.9015{col 48}  0.0796{col 58}  -0.0049{col 68}   0.0774
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0220{col 27}   0.0076{col 38} -2.9006{col 48}  0.0124{col 58}  -0.0383{col 68}  -0.0056
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. eststo highpov_admin
{txt}
{com}. 
. estout lowpov_admin highpov_admin, cells(b(star fmt(%9.3f)) se(par))                ///
>         stats(r2_a N, fmt(%9.3f %9.0g) labels(R-squared))      ///
>         legend label collabels(none) varlabels(_cons Constant)
{res}
{txt}{hline 52}
{txt}                     lowpov_admin    highpov_ad~n   
{txt}{hline 52}
{txt}_t                  {res}        0.053***        0.054***{txt}
                    {res}      (0.005)         (0.011)   {txt}
{txt}_x2003              {res}       -0.112**        -0.162   {txt}
                    {res}      (0.031)         (0.098)   {txt}
{txt}_x_t2003            {res}       -0.047***       -0.017   {txt}
                    {res}      (0.008)         (0.023)   {txt}
{txt}_x2010              {res}        0.102          -0.030   {txt}
                    {res}      (0.050)         (0.055)   {txt}
{txt}_x_t2010            {res}       -0.021*         -0.058*  {txt}
                    {res}      (0.009)         (0.021)   {txt}
{txt}Constant            {res}        1.016***        1.005***{txt}
                    {res}      (0.021)         (0.034)   {txt}
{txt}{hline 52}
{txt}R-squared           {res}                                {txt}
{txt}N                   {res}           19              19   {txt}
{txt}{hline 52}
{txt}* p<0.05, ** p<0.01, *** p<0.001

{com}. 
. //Table 6: Technical Capacity in Low Poverty and High Poverty Counties ITSA, 1997-2015
. 
. //Low Poverty
. use "NCES Capacity Data and Saipe County Subgroup 9715.dta", clear
{txt}
{com}. keep if pov==1 
{txt}(76 observations deleted)

{com}. tsset year 
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa instruction_county, single trperiod(2003 2010) lag(1) fig posttrend //Figure 5


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}    126.24
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}instructio~y{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0081253{col 26}{space 2} .0012681{col 37}{space 1}    6.41{col 46}{space 3}0.000{col 54}{space 4} .0053857{col 67}{space 3} .0108649
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.0236869{col 26}{space 2}  .010423{col 37}{space 1}   -2.27{col 46}{space 3}0.041{col 54}{space 4}-.0462043{col 67}{space 3}-.0011694
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2} .0102581{col 26}{space 2} .0017635{col 37}{space 1}    5.82{col 46}{space 3}0.000{col 54}{space 4} .0064482{col 67}{space 3} .0140679
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2}-.0451613{col 26}{space 2} .0249379{col 37}{space 1}   -1.81{col 46}{space 3}0.093{col 54}{space 4}-.0990364{col 67}{space 3} .0087139
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0262345{col 26}{space 2} .0055676{col 37}{space 1}   -4.71{col 46}{space 3}0.000{col 54}{space 4}-.0382625{col 67}{space 3}-.0142065
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0647112{col 26}{space 2} .0023784{col 37}{space 1}   27.21{col 46}{space 3}0.000{col 54}{space 4} .0595729{col 67}{space 3} .0698495
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0184{col 27}   0.0016{col 38} 11.5510{col 48}  0.0000{col 58}   0.0149{col 68}   0.0218
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0079{col 27}   0.0058{col 38} -1.3440{col 48}  0.2019{col 58}  -0.0205{col 68}   0.0048
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. eststo lowpov_instruction
{txt}
{com}. 
. //High Poverty
. use "NCES Capacity Data and Saipe County Subgroup 9715.dta", clear
{txt}
{com}. keep if pov==5 
{txt}(76 observations deleted)

{com}. tsset year 
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa instruction_county, single trperiod(2003 2010) lag(1) fig posttrend //Figure 6


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}    306.32
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}instructio~y{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0043924{col 26}{space 2} .0006546{col 37}{space 1}    6.71{col 46}{space 3}0.000{col 54}{space 4} .0029781{col 67}{space 3} .0058066
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.0046723{col 26}{space 2}  .007954{col 37}{space 1}   -0.59{col 46}{space 3}0.567{col 54}{space 4} -.021856{col 67}{space 3} .0125113
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2} .0048884{col 26}{space 2} .0027639{col 37}{space 1}    1.77{col 46}{space 3}0.100{col 54}{space 4}-.0010825{col 67}{space 3} .0108594
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2}-.0291314{col 26}{space 2} .0136224{col 37}{space 1}   -2.14{col 46}{space 3}0.052{col 54}{space 4}-.0585608{col 67}{space 3} .0002979
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0073116{col 26}{space 2} .0024449{col 37}{space 1}   -2.99{col 46}{space 3}0.010{col 54}{space 4}-.0125934{col 67}{space 3}-.0020297
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0744308{col 26}{space 2} .0022875{col 37}{space 1}   32.54{col 46}{space 3}0.000{col 54}{space 4}  .069489{col 67}{space 3} .0793725
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0093{col 27}   0.0026{col 38}  3.5760{col 48}  0.0034{col 58}   0.0037{col 68}   0.0149
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0020{col 27}   0.0008{col 38}  2.3806{col 48}  0.0333{col 58}   0.0002{col 68}   0.0038
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. eststo highpov_instruction
{txt}
{com}. 
. estout lowpov_instruction highpov_instruction, cells(b(star fmt(%9.3f)) se(par))                ///
>         stats(r2_a N, fmt(%9.3f %9.0g) labels(R-squared))      ///
>         legend label collabels(none) varlabels(_cons Constant)
{res}
{txt}{hline 52}
{txt}                     lowpov_ins~n    highpov_in~n   
{txt}{hline 52}
{txt}_t                  {res}        0.008***        0.004***{txt}
                    {res}      (0.001)         (0.001)   {txt}
{txt}_x2003              {res}       -0.024*         -0.005   {txt}
                    {res}      (0.010)         (0.008)   {txt}
{txt}_x_t2003            {res}        0.010***        0.005   {txt}
                    {res}      (0.002)         (0.003)   {txt}
{txt}_x2010              {res}       -0.045          -0.029   {txt}
                    {res}      (0.025)         (0.014)   {txt}
{txt}_x_t2010            {res}       -0.026***       -0.007*  {txt}
                    {res}      (0.006)         (0.002)   {txt}
{txt}Constant            {res}        0.065***        0.074***{txt}
                    {res}      (0.002)         (0.002)   {txt}
{txt}{hline 52}
{txt}R-squared           {res}                                {txt}
{txt}N                   {res}           19              19   {txt}
{txt}{hline 52}
{txt}* p<0.05, ** p<0.01, *** p<0.001

{com}. 
. 
. 
. //Robustness checks
. 
. 
. //Figure 7: State Administrative Capacity ITSA, 1997-2015
. 
. use "StateOtherEducationData.dta", clear
{txt}
{com}. collapse (sum) othereducationemployees, by(year)
{txt}
{com}. merge 1:1 year using "NCES Gov Capacity and NCCS Orgs By Year.dta"
{res}{txt}{p 0 7 2}
(note: variable
year was 
int, now float to accommodate using data's values)
{p_end}

{col 5}Result{col 38}# of obs.
{col 5}{hline 41}
{col 5}not matched{col 30}{res}               0
{txt}{col 5}matched{col 30}{res}              19{txt}  (_merge==3)
{col 5}{hline 41}

{com}. 
. save "StateOtherEducationData_9715.dta", replace
{txt}file StateOtherEducationData_9715.dta saved

{com}. 
. use "StateOtherEducationData_9715.dta", clear
{txt}
{com}. gen othered_weighted = (othereducationemployees/member)*100
{txt}
{com}. tsset year
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa othered_weighted, single trperiod(2003 2010) lag(1) fig posttrend //Figure 7


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}     69.39
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}othered_we~d{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0019559{col 26}{space 2} .0016736{col 37}{space 1}    1.17{col 46}{space 3}0.264{col 54}{space 4}-.0016596{col 67}{space 3} .0055715
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2}-.0253522{col 26}{space 2} .0087344{col 37}{space 1}   -2.90{col 46}{space 3}0.012{col 54}{space 4}-.0442217{col 67}{space 3}-.0064826
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2}-.0029019{col 26}{space 2} .0016304{col 37}{space 1}   -1.78{col 46}{space 3}0.098{col 54}{space 4} -.006424{col 67}{space 3} .0006203
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2}-.0059164{col 26}{space 2}  .003617{col 37}{space 1}   -1.64{col 46}{space 3}0.126{col 54}{space 4}-.0137305{col 67}{space 3} .0018977
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2}-.0004073{col 26}{space 2} .0008434{col 37}{space 1}   -0.48{col 46}{space 3}0.637{col 54}{space 4}-.0022295{col 67}{space 3} .0014148
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .1996007{col 26}{space 2} .0040065{col 37}{space 1}   49.82{col 46}{space 3}0.000{col 54}{space 4} .1909451{col 67}{space 3} .2082563
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0009{col 27}   0.0008{col 38} -1.1883{col 48}  0.2560{col 58}  -0.0027{col 68}   0.0008
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}  -0.0014{col 27}   0.0002{col 38} -8.1358{col 48}  0.0000{col 58}  -0.0017{col 68}  -0.0010
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. 
. eststo state
{txt}
{com}. 
. estout state, cells(b(star fmt(%9.3f)) se(par))                ///
>         stats(r2_a N, fmt(%9.3f %9.0g) labels(R-squared))      ///
>         legend label collabels(none) varlabels(_cons Constant)
{res}
{txt}{hline 36}
{txt}                            state   
{txt}{hline 36}
{txt}_t                  {res}        0.002   {txt}
                    {res}      (0.002)   {txt}
{txt}_x2003              {res}       -0.025*  {txt}
                    {res}      (0.009)   {txt}
{txt}_x_t2003            {res}       -0.003   {txt}
                    {res}      (0.002)   {txt}
{txt}_x2010              {res}       -0.006   {txt}
                    {res}      (0.004)   {txt}
{txt}_x_t2010            {res}       -0.000   {txt}
                    {res}      (0.001)   {txt}
{txt}Constant            {res}        0.200***{txt}
                    {res}      (0.004)   {txt}
{txt}{hline 36}
{txt}R-squared           {res}                {txt}
{txt}N                   {res}           19   {txt}
{txt}{hline 36}
{txt}* p<0.05, ** p<0.01, *** p<0.001

{com}. 
. 
. //Figure 8: Nongovernmental Capacity ITSA, 1997-2015
. use  "NCES Gov Capacity and NCCS Orgs By Year.dta", replace
{txt}( )

{com}. tsset year
{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit
{txt}
{com}. itsa service_weighted, single trperiod(2003 2010) lag(1) fig posttrend //Figure 8


{res}{txt}{col 9}time variable:  {res}{col 25}year, 1997 to 2015
{txt}{col 17}delta:  {res}1 unit

{txt}Regression with Newey-West standard errors{col 49}Number of obs{col 67}= {res}        19
{txt}maximum lag: {res}1{col 49}{txt}F(  5,        13){col 67}= {res}    162.29
{col 49}{txt}Prob > F{col 67}= {res}    0.0000

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}  Newey-West
{col 1}service_we~d{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 10}_t {c |}{col 14}{res}{space 2} .0000272{col 26}{space 2} 5.73e-06{col 37}{space 1}    4.75{col 46}{space 3}0.000{col 54}{space 4} .0000149{col 67}{space 3} .0000396
{txt}{space 6}_x2003 {c |}{col 14}{res}{space 2} .0000338{col 26}{space 2} .0000373{col 37}{space 1}    0.91{col 46}{space 3}0.381{col 54}{space 4}-.0000467{col 67}{space 3} .0001144
{txt}{space 4}_x_t2003 {c |}{col 14}{res}{space 2}-4.00e-08{col 26}{space 2} 8.57e-06{col 37}{space 1}   -0.00{col 46}{space 3}0.996{col 54}{space 4}-.0000185{col 67}{space 3} .0000185
{txt}{space 6}_x2010 {c |}{col 14}{res}{space 2} 2.31e-06{col 26}{space 2}  .000036{col 37}{space 1}    0.06{col 46}{space 3}0.950{col 54}{space 4}-.0000756{col 67}{space 3} .0000802
{txt}{space 4}_x_t2010 {c |}{col 14}{res}{space 2} 1.04e-07{col 26}{space 2} .0000117{col 37}{space 1}    0.01{col 46}{space 3}0.993{col 54}{space 4}-.0000252{col 67}{space 3} .0000254
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} .0002619{col 26}{space 2} .0000161{col 37}{space 1}   16.32{col 46}{space 3}0.000{col 54}{space 4} .0002273{col 67}{space 3} .0002966
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}


{col 20} Postintervention Linear Trend: 2003 

Treated: _b[_t]+_b[_x_t2003]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0000{col 27}   0.0000{col 38}  3.6407{col 48}  0.0030{col 58}   0.0000{col 68}   0.0000
{txt}{hline 13}{c BT}{hline 64}


{col 20} Postintervention Linear Trend: 2010 

Treated: _b[_t]+_b[_x_t2003]+_b[_x_t2010]
{hline 13}{c TT}{hline 64}
Linear Trend {c |}{col 21}Coeff {col 29}Std. Err.{col 43}t{col 50}P>|t|{col 59}[95% Conf. Interval]
{hline 13}{c +}{hline 64}
{col 1}   Treated{col 14}{c |}{res}{col 18}   0.0000{col 27}   0.0000{col 38}  4.1575{col 48}  0.0011{col 58}   0.0000{col 68}   0.0000
{txt}{hline 13}{c BT}{hline 64}
{res}{txt}
{com}. 
. 
. eststo ngo
{txt}
{com}. 
. estout ngo, cells(b(star fmt(%9.3f)) se(par))                ///
>         stats(r2_a N, fmt(%9.3f %9.0g) labels(R-squared))      ///
>         legend label collabels(none) varlabels(_cons Constant)
{res}
{txt}{hline 36}
{txt}                              ngo   
{txt}{hline 36}
{txt}_t                  {res}        0.000***{txt}
                    {res}      (0.000)   {txt}
{txt}_x2003              {res}        0.000   {txt}
                    {res}      (0.000)   {txt}
{txt}_x_t2003            {res}       -0.000   {txt}
                    {res}      (0.000)   {txt}
{txt}_x2010              {res}        0.000   {txt}
                    {res}      (0.000)   {txt}
{txt}_x_t2010            {res}        0.000   {txt}
                    {res}      (0.000)   {txt}
{txt}Constant            {res}        0.000***{txt}
                    {res}      (0.000)   {txt}
{txt}{hline 36}
{txt}R-squared           {res}                {txt}
{txt}N                   {res}           19   {txt}
{txt}{hline 36}
{txt}* p<0.05, ** p<0.01, *** p<0.001

{com}. 
{txt}end of do-file

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/willsec/Desktop/ReplicationFile.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}21 Jul 2021, 17:09:42
{txt}{.-}
{smcl}
{txt}{sf}{ul off}